Mapping Brooklyn Borough to visualize the areas of interest to find out the food desert

As per the USDA, an area can be classified as food desert if it meets the following two conditions:

  1. Poverty Rate is greater than or equal to 20% or a household with income less than the federal poverty level of USD 17,050 for a family of four in 2000

  2. At least 500 people or 33% of the population is located more than 1 mile (Urban) and 10 miles (Rural) from the nearest supermarket or grocery store

Insights found during Visualization

In Brooklyn, there are multiple census tracts having greater than or equal to 20% poverty rate which meets condition one but not a single tract meets condition 2

Database 1: New York State Map

Database 2: Food Access Research Atlas 2019 - Kings County

Visualizing Low Income and Low Access Census Tracts which are 1/2 mile from nearest supermarket

Database 3: Grocery Store 2003 - 2017

This database contains the following

  1. 445110: supermarkets and grocery stores, excluding convenience stores.
  2. 4452: all specialty food stores. These include meat, fish, and seafood markets, produce markets, baked goods stores, and spice stores.
  3. 452311: warehouse clubs and supercenters, which sell fresh food alongside canned and packaged foods and other types of merchandise (such as clothing and furniture).

2017 Grocery data was used as a proxy to 2019 Food Access Research Atlas data

Database 4: Socio-Economic Data

Database 5: Eating & Drinking Data

This database contains the following

  1. 7225: all restaurants and eating places.
  2. 722511: full-service restaurants where patrons order and are served while seated.
  3. 722513: limited service restaurants, e.g. fast-food restaurants.
  4. 722515: snack and nonalcoholic beverage bars, such as coffee shops, doughnut or bagel shops, and ice cream parlors.
  5. 722410: drinking places (alcoholic beverages), such as bars, taverns, and cocktail lounges.

2017 Eating & Drinking Data is used as a proxy to 2019 Food Access Research Atlas data

Visualizing Poverty Rates with Median Family Income, Restaurants, Bars and Grocery stores

Visualizing Fast food restaurants (in blue) with median family income, poverty rates, higher education, SNAP Benefits(%), grocery stores

Visualing Poverty Rates with Demographics and Socio-Economic Factors in Brooklyn - PART 1

Demographic factors considered

  1. White Population (%)
  2. Black Population (%)
  3. Asian Population (%)
  4. Native Alaskan/Native Population (%)
  5. Hispanic Population (%)
  6. Other/Mixed Population (%)

Socio-Economic factors considered:

  1. Median Family Income
  2. Proportion of civilian employed with professional studies
  3. Proportion of households with public assisted income/food stamps

Visualing Poverty Rates with Demographics and Socio-Economic Factors in Brooklyn - PART 2

Demographic factors considered

  1. White Population (%)
  2. Black Population (%)
  3. Asian Population (%)
  4. Native Alaskan/Native Population (%)
  5. Hispanic Population (%)
  6. Other/Mixed Population (%)

Socio-Economic factors considered:

  1. Median Family Income
  2. Proportion of female-headed families with kids
  3. Proportion of Single-parent families with kids

Visualing Poverty Rates with Demographics and Socio-Economic Factors in Brooklyn - PART 3

Demographics

  1. White Population (%)
  2. Black Population (%)
  3. Asian Population (%)
  4. Native Alaskan/Native Population (%)
  5. Hispanic Population (%)
  6. Other/Mixed Population (%)

Socio-Economic factors considered:

The socio-economic database has two important metrics to measure the level of socio-economic equity

  1. Affluence_16_20
  2. Disadvantage_16_20

The Affluence factor is the average of three variables given below

  1. Proportions of people with Bachelor's degree or higher
  2. Propotions of families with income more than USD 125K
  3. Propotions of civilians employed in business, management, science and arts occupation

The Disadvantages factor is the average of three variables given below

  1. Proportion of families with income less than USD 40k
  2. Proportion people w/ income in the past 12 months below poverty level
  3. Proportion of households with public assistance income or foodstamps